Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 514 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 40.3 KiB |
| Average record size in memory | 80.2 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 2 |
link has a high cardinality: 461 distinct values | High cardinality |
name has a high cardinality: 459 distinct values | High cardinality |
age is highly correlated with amount_bricks and 1 other fields | High correlation |
amount_bricks is highly correlated with age and 1 other fields | High correlation |
price is highly correlated with age and 1 other fields | High correlation |
rating_amount is highly correlated with rating_worth and 1 other fields | High correlation |
rating_worth is highly correlated with rating_amount and 1 other fields | High correlation |
rating_fun is highly correlated with rating_amount and 1 other fields | High correlation |
age is highly correlated with amount_bricks and 1 other fields | High correlation |
amount_bricks is highly correlated with age and 1 other fields | High correlation |
price is highly correlated with age and 1 other fields | High correlation |
rating_amount is highly correlated with rating_worth and 1 other fields | High correlation |
rating_worth is highly correlated with rating_amount and 1 other fields | High correlation |
rating_fun is highly correlated with rating_amount and 1 other fields | High correlation |
Unnamed: 0 is highly correlated with rating_amount and 2 other fields | High correlation |
age is highly correlated with rating_amount and 2 other fields | High correlation |
amount_bricks is highly correlated with price and 3 other fields | High correlation |
price is highly correlated with amount_bricks and 3 other fields | High correlation |
rating_amount is highly correlated with Unnamed: 0 and 5 other fields | High correlation |
rating_worth is highly correlated with Unnamed: 0 and 5 other fields | High correlation |
rating_fun is highly correlated with Unnamed: 0 and 5 other fields | High correlation |
amount_bricks is highly correlated with price and 1 other fields | High correlation |
price is highly correlated with amount_bricks and 3 other fields | High correlation |
rating_amount is highly correlated with price and 2 other fields | High correlation |
Unnamed: 0 is highly correlated with age | High correlation |
product_number is highly correlated with price | High correlation |
rating_fun is highly correlated with price and 2 other fields | High correlation |
age is highly correlated with amount_bricks and 1 other fields | High correlation |
rating_worth is highly correlated with rating_amount and 1 other fields | High correlation |
Unnamed: 0 is uniformly distributed | Uniform |
link is uniformly distributed | Uniform |
name is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
product_number has 21 (4.1%) zeros | Zeros |
price has 21 (4.1%) zeros | Zeros |
rating_amount has 450 (87.5%) zeros | Zeros |
rating_worth has 450 (87.5%) zeros | Zeros |
rating_fun has 450 (87.5%) zeros | Zeros |
Reproduction
| Analysis started | 2021-09-20 14:16:25.148566 |
|---|---|
| Analysis finished | 2021-09-20 14:17:37.528694 |
| Duration | 1 minute and 12.38 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 514 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 256.5 |
| Minimum | 0 |
|---|---|
| Maximum | 513 |
| Zeros | 1 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25.65 |
| Q1 | 128.25 |
| median | 256.5 |
| Q3 | 384.75 |
| 95-th percentile | 487.35 |
| Maximum | 513 |
| Range | 513 |
| Interquartile range (IQR) | 256.5 |
Descriptive statistics
| Standard deviation | 148.5232866 |
|---|---|
| Coefficient of variation (CV) | 0.5790381544 |
| Kurtosis | -1.2 |
| Mean | 256.5 |
| Median Absolute Deviation (MAD) | 128.5 |
| Skewness | 0 |
| Sum | 131841 |
| Variance | 22059.16667 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | 0.2% |
| 385 | 1 | 0.2% |
| 351 | 1 | 0.2% |
| 350 | 1 | 0.2% |
| 349 | 1 | 0.2% |
| 348 | 1 | 0.2% |
| 347 | 1 | 0.2% |
| 346 | 1 | 0.2% |
| 345 | 1 | 0.2% |
| 344 | 1 | 0.2% |
| Other values (504) | 504 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 513 | 1 | |
| 512 | 1 | |
| 511 | 1 | |
| 510 | 1 | |
| 509 | 1 | |
| 508 | 1 | |
| 507 | 1 | |
| 506 | 1 | |
| 505 | 1 | |
| 504 | 1 |
| Distinct | 461 |
|---|---|
| Distinct (%) | 89.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| https://www.lego.com/da-dk/product/batman-40386 | 3 |
|---|---|
| https://www.lego.com/da-dk/product/the-joker-40428 | 3 |
| https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109 | 2 |
| https://www.lego.com/da-dk/product/first-order-stormtrooper-40391 | 2 |
| https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496 | 2 |
| Other values (456) |
Length
| Max length | 105 |
|---|---|
| Median length | 61 |
| Mean length | 61.92412451 |
| Min length | 44 |
Characters and Unicode
| Total characters | 31.829 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 410 ? |
|---|---|
| Unique (%) | 79.8% |
Sample
| 1st row | https://www.lego.com/da-dk/product/empire-state-building-21046 |
|---|---|
| 2nd row | https://www.lego.com/da-dk/product/statue-of-liberty-21042 |
| 3rd row | https://www.lego.com/da-dk/product/taj-mahal-21056 |
| 4th row | https://www.lego.com/da-dk/product/trafalgar-square-21045 |
| 5th row | https://www.lego.com/da-dk/product/the-white-house-21054 |
Common Values
| Value | Count | Frequency (%) |
| https://www.lego.com/da-dk/product/batman-40386 | 3 | 0.6% |
| https://www.lego.com/da-dk/product/the-joker-40428 | 3 | 0.6% |
| https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/first-order-stormtrooper-40391 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/belle-bottom-kevin-and-bob-40421 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/disney-s-mickey-mouse-31202 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/the-ice-castle-43197 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/bruni-the-salamander-buildable-character-43186 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/4x4-x-treme-off-roader-42099 | 2 | 0.4% |
| Other values (451) | 492 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| https://www.lego.com/da-dk/product/batman-40386 | 3 | 0.6% |
| https://www.lego.com/da-dk/product/the-joker-40428 | 3 | 0.6% |
| https://www.lego.com/da-dk/product/app-controlled-top-gear-rally-car-42109 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/first-order-stormtrooper-40391 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/voldemort-nagini-bellatrix-40496 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/belle-bottom-kevin-and-bob-40421 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/disney-s-mickey-mouse-31202 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/the-ice-castle-43197 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/bruni-the-salamander-buildable-character-43186 | 2 | 0.4% |
| https://www.lego.com/da-dk/product/4x4-x-treme-off-roader-42099 | 2 | 0.4% |
| Other values (451) | 492 |
Most occurring characters
| Value | Count | Frequency (%) |
| / | 2570 | 8.1% |
| - | 2286 | 7.2% |
| t | 2249 | 7.1% |
| o | 2218 | 7.0% |
| d | 1856 | 5.8% |
| w | 1643 | 5.2% |
| e | 1596 | 5.0% |
| c | 1422 | 4.5% |
| a | 1397 | 4.4% |
| r | 1306 | 4.1% |
| Other values (31) | 13286 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22730 | |
| Other Punctuation | 4112 | 12.9% |
| Decimal Number | 2699 | 8.5% |
| Dash Punctuation | 2286 | 7.2% |
| Other Letter | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 2249 | 9.9% |
| o | 2218 | 9.8% |
| d | 1856 | 8.2% |
| w | 1643 | 7.2% |
| e | 1596 | 7.0% |
| c | 1422 | 6.3% |
| a | 1397 | 6.1% |
| r | 1306 | 5.7% |
| p | 1259 | 5.5% |
| s | 1122 | 4.9% |
| Other values (16) | 6662 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 507 | |
| 0 | 377 | |
| 4 | 317 | |
| 7 | 277 | |
| 2 | 248 | |
| 3 | 218 | |
| 9 | 200 | 7.4% |
| 6 | 197 | 7.3% |
| 5 | 192 | 7.1% |
| 8 | 166 | 6.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2570 | |
| . | 1028 | 25.0% |
| : | 514 | 12.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2286 |
Other Letter
| Value | Count | Frequency (%) |
| ǀ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22732 | |
| Common | 9097 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 2249 | 9.9% |
| o | 2218 | 9.8% |
| d | 1856 | 8.2% |
| w | 1643 | 7.2% |
| e | 1596 | 7.0% |
| c | 1422 | 6.3% |
| a | 1397 | 6.1% |
| r | 1306 | 5.7% |
| p | 1259 | 5.5% |
| s | 1122 | 4.9% |
| Other values (17) | 6664 |
Common
| Value | Count | Frequency (%) |
| / | 2570 | |
| - | 2286 | |
| . | 1028 | 11.3% |
| : | 514 | 5.7% |
| 1 | 507 | 5.6% |
| 0 | 377 | 4.1% |
| 4 | 317 | 3.5% |
| 7 | 277 | 3.0% |
| 2 | 248 | 2.7% |
| 3 | 218 | 2.4% |
| Other values (4) | 755 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31827 | |
| Latin Ext B | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| / | 2570 | 8.1% |
| - | 2286 | 7.2% |
| t | 2249 | 7.1% |
| o | 2218 | 7.0% |
| d | 1856 | 5.8% |
| w | 1643 | 5.2% |
| e | 1596 | 5.0% |
| c | 1422 | 4.5% |
| a | 1397 | 4.4% |
| r | 1306 | 4.1% |
| Other values (30) | 13284 |
Latin Ext B
| Value | Count | Frequency (%) |
| ǀ | 2 |
| Distinct | 459 |
|---|---|
| Distinct (%) | 89.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| Batman™ | 3 |
|---|---|
| Jokeren | 3 |
| Firhjulstrukket X-trem offroader | 2 |
| Daily Bugle | 2 |
| Joakim von And, Rip, Rap og Rup | 2 |
| Other values (454) |
Length
| Max length | 67 |
|---|---|
| Median length | 20 |
| Mean length | 21.07003891 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10.830 |
|---|---|
| Distinct characters | 87 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 5 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 406 ? |
|---|---|
| Unique (%) | 79.0% |
Sample
| 1st row | Empire State Building |
|---|---|
| 2nd row | Frihedsgudinden |
| 3rd row | Taj Mahal |
| 4th row | Trafalgar Square |
| 5th row | Det Hvide Hus |
Common Values
| Value | Count | Frequency (%) |
| Batman™ | 3 | 0.6% |
| Jokeren | 3 | 0.6% |
| Firhjulstrukket X-trem offroader | 2 | 0.4% |
| Daily Bugle | 2 | 0.4% |
| Joakim von And, Rip, Rap og Rup | 2 | 0.4% |
| Voldemort™, Nagini og Bellatrix | 2 | 0.4% |
| Belle Bottom, Kevin og Bob | 2 | 0.4% |
| Gru, Stuart og Otto | 2 | 0.4% |
| Frost – isslot | 2 | 0.4% |
| Arendal slotsby | 2 | 0.4% |
| Other values (449) | 492 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| og | 52 | 3.8% |
| – | 33 | 2.4% |
| lego® | 28 | 2.0% |
| med | 17 | 1.2% |
| batman™ | 13 | 0.9% |
| mod | 13 | 0.9% |
| klodser | 11 | 0.8% |
| mouse | 9 | 0.7% |
| mickey | 9 | 0.7% |
| i | 9 | 0.7% |
| Other values (798) | 1175 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1026 | 9.5% |
| 850 | 7.8% | |
| r | 755 | 7.0% |
| a | 645 | 6.0% |
| s | 601 | 5.5% |
| n | 587 | 5.4% |
| o | 575 | 5.3% |
| t | 571 | 5.3% |
| i | 513 | 4.7% |
| l | 418 | 3.9% |
| Other values (77) | 4289 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8282 | |
| Uppercase Letter | 1261 | 11.6% |
| Space Separator | 855 | 7.9% |
| Dash Punctuation | 180 | 1.7% |
| Other Symbol | 109 | 1.0% |
| Decimal Number | 85 | 0.8% |
| Other Punctuation | 51 | 0.5% |
| Format | 3 | < 0.1% |
| Other Letter | 2 | < 0.1% |
| Initial Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1026 | |
| r | 755 | 9.1% |
| a | 645 | 7.8% |
| s | 601 | 7.3% |
| n | 587 | 7.1% |
| o | 575 | 6.9% |
| t | 571 | 6.9% |
| i | 513 | 6.2% |
| l | 418 | 5.0% |
| d | 387 | 4.7% |
| Other values (21) | 2204 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 126 | 10.0% |
| B | 120 | 9.5% |
| S | 96 | 7.6% |
| E | 92 | 7.3% |
| A | 71 | 5.6% |
| G | 65 | 5.2% |
| H | 61 | 4.8% |
| K | 60 | 4.8% |
| P | 59 | 4.7% |
| L | 59 | 4.7% |
| Other values (17) | 452 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 19 | |
| 9 | 16 | |
| 8 | 14 | |
| 2 | 11 | |
| 3 | 10 | |
| 0 | 8 | |
| 5 | 3 | 3.5% |
| 7 | 2 | 2.4% |
| 6 | 1 | 1.2% |
| 4 | 1 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 21 | |
| : | 14 | |
| . | 6 | 11.8% |
| / | 3 | 5.9% |
| ' | 2 | 3.9% |
| " | 2 | 3.9% |
| ! | 1 | 2.0% |
| & | 1 | 2.0% |
| # | 1 | 2.0% |
Space Separator
| Value | Count | Frequency (%) |
| 850 | ||
| 5 | 0.6% |
Other Symbol
| Value | Count | Frequency (%) |
| ™ | 73 | |
| ® | 36 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 147 | |
| – | 33 | 18.3% |
Format
| Value | Count | Frequency (%) |
| | 3 |
Other Letter
| Value | Count | Frequency (%) |
| ǀ | 2 |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 1 |
Final Punctuation
| Value | Count | Frequency (%) |
| ” | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9545 | |
| Common | 1285 | 11.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1026 | 10.7% |
| r | 755 | 7.9% |
| a | 645 | 6.8% |
| s | 601 | 6.3% |
| n | 587 | 6.1% |
| o | 575 | 6.0% |
| t | 571 | 6.0% |
| i | 513 | 5.4% |
| l | 418 | 4.4% |
| d | 387 | 4.1% |
| Other values (49) | 3467 |
Common
| Value | Count | Frequency (%) |
| 850 | ||
| - | 147 | 11.4% |
| ™ | 73 | 5.7% |
| ® | 36 | 2.8% |
| – | 33 | 2.6% |
| , | 21 | 1.6% |
| 1 | 19 | 1.5% |
| 9 | 16 | 1.2% |
| 8 | 14 | 1.1% |
| : | 14 | 1.1% |
| Other values (18) | 62 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10526 | |
| Latin 1 Sup | 191 | 1.8% |
| Letterlike Symbols | 73 | 0.7% |
| Punctuation | 38 | 0.4% |
| Latin Ext B | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1026 | 9.7% |
| 850 | 8.1% | |
| r | 755 | 7.2% |
| a | 645 | 6.1% |
| s | 601 | 5.7% |
| n | 587 | 5.6% |
| o | 575 | 5.5% |
| t | 571 | 5.4% |
| i | 513 | 4.9% |
| l | 418 | 4.0% |
| Other values (63) | 3985 |
Letterlike Symbols
| Value | Count | Frequency (%) |
| ™ | 73 |
Punctuation
| Value | Count | Frequency (%) |
| – | 33 | |
| | 3 | 7.9% |
| “ | 1 | 2.6% |
| ” | 1 | 2.6% |
Latin 1 Sup
| Value | Count | Frequency (%) |
| æ | 55 | |
| ø | 48 | |
| å | 40 | |
| ® | 36 | |
| 5 | 2.6% | |
| Æ | 4 | 2.1% |
| á | 2 | 1.0% |
| é | 1 | 0.5% |
Latin Ext B
| Value | Count | Frequency (%) |
| ǀ | 2 |
| Distinct | 15 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.642023346 |
| Minimum | 1 |
|---|---|
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 18 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 4.429682861 |
|---|---|
| Coefficient of variation (CV) | 0.5125747389 |
| Kurtosis | 0.09835324228 |
| Mean | 8.642023346 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.9736949455 |
| Sum | 4442 |
| Variance | 19.62209025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 6 | 94 | |
| 8 | 89 | |
| 7 | 65 | |
| 18 | 58 | |
| 10 | 45 | |
| 4 | 38 | |
| 9 | 28 | 5.4% |
| 16 | 25 | 4.9% |
| 5 | 25 | 4.9% |
| 2 | 21 | 4.1% |
| Other values (5) | 26 | 5.1% |
| Value | Count | Frequency (%) |
| 1 | 4 | 0.8% |
| 2 | 21 | 4.1% |
| 3 | 3 | 0.6% |
| 4 | 38 | |
| 5 | 25 | 4.9% |
| 6 | 94 | |
| 7 | 65 | |
| 8 | 89 | |
| 9 | 28 | 5.4% |
| 10 | 45 |
| Value | Count | Frequency (%) |
| 18 | 58 | |
| 16 | 25 | 4.9% |
| 14 | 5 | 1.0% |
| 12 | 9 | 1.8% |
| 11 | 5 | 1.0% |
| 10 | 45 | |
| 9 | 28 | 5.4% |
| 8 | 89 | |
| 7 | 65 | |
| 6 | 94 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 71.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 833.9338521 |
| Minimum | 1 |
|---|---|
| Maximum | 11695 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10.65 |
| Q1 | 118.25 |
| median | 386.5 |
| Q3 | 973.25 |
| 95-th percentile | 3318.25 |
| Maximum | 11695 |
| Range | 11694 |
| Interquartile range (IQR) | 855 |
Descriptive statistics
| Standard deviation | 1246.781419 |
|---|---|
| Coefficient of variation (CV) | 1.495060328 |
| Kurtosis | 17.6695095 |
| Mean | 833.9338521 |
| Median Absolute Deviation (MAD) | 304.5 |
| Skewness | 3.416114376 |
| Sum | 428642 |
| Variance | 1554463.906 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 18 | 3.5% |
| 50 | 10 | 1.9% |
| 90 | 6 | 1.2% |
| 33 | 5 | 1.0% |
| 34 | 5 | 1.0% |
| 36 | 4 | 0.8% |
| 234 | 4 | 0.8% |
| 73 | 4 | 0.8% |
| 565 | 4 | 0.8% |
| 466 | 4 | 0.8% |
| Other values (356) | 450 |
| Value | Count | Frequency (%) |
| 1 | 18 | |
| 7 | 2 | 0.4% |
| 8 | 3 | 0.6% |
| 10 | 3 | 0.6% |
| 11 | 2 | 0.4% |
| 13 | 1 | 0.2% |
| 17 | 1 | 0.2% |
| 18 | 1 | 0.2% |
| 23 | 2 | 0.4% |
| 24 | 2 | 0.4% |
| Value | Count | Frequency (%) |
| 11695 | 1 | |
| 9036 | 1 | |
| 7541 | 1 | |
| 6020 | 1 | |
| 5685 | 1 | |
| 5544 | 1 | |
| 5509 | 1 | |
| 5100 | 1 | |
| 4784 | 1 | |
| 4249 | 2 |
| Distinct | 444 |
|---|---|
| Distinct (%) | 86.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.560528431 × 1018 |
| Minimum | 0 |
|---|---|
| Maximum | 2.0004312 × 1020 |
| Zeros | 21 |
| Zeros (%) | 4.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.027140271 × 1014 |
| Q1 | 3.1100061 × 1014 |
| median | 4.209792098 × 1014 |
| Q3 | 7.531150312 × 1014 |
| 95-th percentile | 8.001615016 × 1014 |
| Maximum | 2.0004312 × 1020 |
| Range | 2.0004312 × 1020 |
| Interquartile range (IQR) | 4.421144211 × 1014 |
Descriptive statistics
| Standard deviation | 1.759502963 × 1019 |
|---|---|
| Coefficient of variation (CV) | 11.27504586 |
| Kurtosis | 124.7271812 |
| Mean | 1.560528431 × 1018 |
| Median Absolute Deviation (MAD) | 2.893228932 × 1014 |
| Skewness | 11.23568835 |
| Sum | 8.021116137 × 1020 |
| Variance | 3.095850678 × 1038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 21 | 4.1% |
| 4.038640386 × 1014 | 3 | 0.6% |
| 4.042840428 × 1014 | 3 | 0.6% |
| 4.04204042 × 1014 | 2 | 0.4% |
| 4.037740377 × 1014 | 2 | 0.4% |
| 4.049640496 × 1014 | 2 | 0.4% |
| 4.042140421 × 1014 | 2 | 0.4% |
| 4.317243172 × 1014 | 2 | 0.4% |
| 2.132621326 × 1014 | 2 | 0.4% |
| 4.2100421 × 1014 | 2 | 0.4% |
| Other values (434) | 473 |
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1.025510255 × 1014 | 1 | 0.2% |
| 1.026110261 × 1014 | 1 | 0.2% |
| 1.026410264 × 1014 | 1 | 0.2% |
| 1.026510265 × 1014 | 1 | 0.2% |
| 1.02701027 × 1014 | 1 | 0.2% |
| 1.027210272 × 1014 | 1 | 0.2% |
| 1.027310273 × 1014 | 2 | 0.4% |
| 1.027410274 × 1014 | 1 | 0.2% |
| 1.027610276 × 1014 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 2.0004312 × 1020 | 1 | |
| 2.0004302 × 1020 | 1 | |
| 2.0004142 × 1020 | 1 | |
| 2.0004092 × 1020 | 1 | |
| 8.540658541 × 1017 | 1 | |
| 8.538658539 × 1017 | 1 | |
| 9.217792178 × 1014 | 1 | |
| 9.217692177 × 1014 | 1 | |
| 8.801588016 × 1014 | 1 | |
| 8.801488015 × 1014 | 1 |
| Distinct | 80 |
|---|---|
| Distinct (%) | 15.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 656.151751 |
| Minimum | 0 |
|---|---|
| Maximum | 6999 |
| Zeros | 21 |
| Zeros (%) | 4.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 180 |
| median | 354 |
| Q3 | 899 |
| 95-th percentile | 2134 |
| Maximum | 6999 |
| Range | 6999 |
| Interquartile range (IQR) | 719 |
Descriptive statistics
| Standard deviation | 790.5202203 |
|---|---|
| Coefficient of variation (CV) | 1.204782612 |
| Kurtosis | 12.84975148 |
| Mean | 656.151751 |
| Median Absolute Deviation (MAD) | 254 |
| Skewness | 2.900690392 |
| Sum | 337262 |
| Variance | 624922.2186 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 180 | 49 | 9.5% |
| 270 | 29 | 5.6% |
| 100 | 27 | 5.3% |
| 449 | 26 | 5.1% |
| 130 | 26 | 5.1% |
| 899 | 25 | 4.9% |
| 549 | 22 | 4.3% |
| 0 | 21 | 4.1% |
| 349 | 20 | 3.9% |
| 649 | 20 | 3.9% |
| Other values (70) | 249 |
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 30 | 6 | 1.2% |
| 40 | 7 | 1.4% |
| 50 | 1 | 0.2% |
| 60 | 8 | 1.6% |
| 70 | 3 | 0.6% |
| 80 | 2 | 0.4% |
| 100 | 27 | |
| 104 | 1 | 0.2% |
| 130 | 26 |
| Value | Count | Frequency (%) |
| 6999 | 1 | |
| 5299 | 1 | |
| 4350 | 1 | |
| 4160 | 1 | |
| 3899 | 1 | |
| 3499 | 1 | |
| 3399 | 2 | |
| 3199 | 2 | |
| 3110 | 1 | |
| 2999 | 1 |
rating_amount
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 18 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5206225681 |
| Minimum | 0 |
|---|---|
| Maximum | 4.9 |
| Zeros | 450 |
| Zeros (%) | 87.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.4 |
| Maximum | 4.9 |
| Range | 4.9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.393497431 |
|---|---|
| Coefficient of variation (CV) | 2.676598204 |
| Kurtosis | 3.600363366 |
| Mean | 0.5206225681 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.344308308 |
| Sum | 267.6 |
| Variance | 1.941835089 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 4.4 | 8 | 1.6% |
| 4.5 | 7 | 1.4% |
| 4 | 7 | 1.4% |
| 4.6 | 7 | 1.4% |
| 4.2 | 6 | 1.2% |
| 3.9 | 5 | 1.0% |
| 4.3 | 5 | 1.0% |
| 4.7 | 5 | 1.0% |
| 3.7 | 3 | 0.6% |
| Other values (8) | 11 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 2.2 | 2 | 0.4% |
| 3.1 | 1 | 0.2% |
| 3.3 | 1 | 0.2% |
| 3.5 | 1 | 0.2% |
| 3.6 | 1 | 0.2% |
| 3.7 | 3 | 0.6% |
| 3.9 | 5 | 1.0% |
| 4 | 7 | 1.4% |
| 4.1 | 3 | 0.6% |
| Value | Count | Frequency (%) |
| 4.9 | 1 | 0.2% |
| 4.8 | 1 | 0.2% |
| 4.7 | 5 | |
| 4.6 | 7 | |
| 4.5 | 7 | |
| 4.4 | 8 | |
| 4.3 | 5 | |
| 4.2 | 6 | |
| 4.1 | 3 | 0.6% |
| 4 | 7 |
rating_worth
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 19 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5145914397 |
| Minimum | 0 |
|---|---|
| Maximum | 4.8 |
| Zeros | 450 |
| Zeros (%) | 87.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.3 |
| Maximum | 4.8 |
| Range | 4.8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.379564417 |
|---|---|
| Coefficient of variation (CV) | 2.680892667 |
| Kurtosis | 3.650945506 |
| Mean | 0.5145914397 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.353587991 |
| Sum | 264.5 |
| Variance | 1.903197981 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 4.4 | 10 | 1.9% |
| 4.1 | 8 | 1.6% |
| 4.3 | 8 | 1.6% |
| 4.2 | 6 | 1.2% |
| 3.9 | 5 | 1.0% |
| 4.7 | 5 | 1.0% |
| 3.8 | 4 | 0.8% |
| 4.6 | 4 | 0.8% |
| 4.8 | 3 | 0.6% |
| Other values (9) | 11 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 1.8 | 1 | 0.2% |
| 2.2 | 1 | 0.2% |
| 2.8 | 1 | 0.2% |
| 3 | 1 | 0.2% |
| 3.4 | 1 | 0.2% |
| 3.6 | 2 | 0.4% |
| 3.7 | 1 | 0.2% |
| 3.8 | 4 | 0.8% |
| 3.9 | 5 | 1.0% |
| Value | Count | Frequency (%) |
| 4.8 | 3 | 0.6% |
| 4.7 | 5 | |
| 4.6 | 4 | 0.8% |
| 4.5 | 2 | 0.4% |
| 4.4 | 10 | |
| 4.3 | 8 | |
| 4.2 | 6 | |
| 4.1 | 8 | |
| 4 | 1 | 0.2% |
| 3.9 | 5 |
rating_fun
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 18 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5206225681 |
| Minimum | 0 |
|---|---|
| Maximum | 4.9 |
| Zeros | 450 |
| Zeros (%) | 87.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.4 |
| Maximum | 4.9 |
| Range | 4.9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.393497431 |
|---|---|
| Coefficient of variation (CV) | 2.676598204 |
| Kurtosis | 3.600363366 |
| Mean | 0.5206225681 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.344308308 |
| Sum | 267.6 |
| Variance | 1.941835089 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 4.4 | 8 | 1.6% |
| 4.5 | 7 | 1.4% |
| 4 | 7 | 1.4% |
| 4.6 | 7 | 1.4% |
| 4.2 | 6 | 1.2% |
| 3.9 | 5 | 1.0% |
| 4.3 | 5 | 1.0% |
| 4.7 | 5 | 1.0% |
| 3.7 | 3 | 0.6% |
| Other values (8) | 11 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 450 | |
| 2.2 | 2 | 0.4% |
| 3.1 | 1 | 0.2% |
| 3.3 | 1 | 0.2% |
| 3.5 | 1 | 0.2% |
| 3.6 | 1 | 0.2% |
| 3.7 | 3 | 0.6% |
| 3.9 | 5 | 1.0% |
| 4 | 7 | 1.4% |
| 4.1 | 3 | 0.6% |
| Value | Count | Frequency (%) |
| 4.9 | 1 | 0.2% |
| 4.8 | 1 | 0.2% |
| 4.7 | 5 | |
| 4.6 | 7 | |
| 4.5 | 7 | |
| 4.4 | 8 | |
| 4.3 | 5 | |
| 4.2 | 6 | |
| 4.1 | 3 | 0.6% |
| 4 | 7 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Unnamed: 0 | link | name | age | amount_bricks | product_number | price | rating_amount | rating_worth | rating_fun | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | https://www.lego.com/da-dk/product/empire-state-building-21046 | Empire State Building | 16 | 1767 | 210462104621046 | 899 | 0.0 | 0.0 | 0.0 |
| 1 | 1 | https://www.lego.com/da-dk/product/statue-of-liberty-21042 | Frihedsgudinden | 16 | 1685 | 210422104221042 | 899 | 0.0 | 0.0 | 0.0 |
| 2 | 2 | https://www.lego.com/da-dk/product/taj-mahal-21056 | Taj Mahal | 18 | 2022 | 210562105621056 | 899 | 0.0 | 0.0 | 0.0 |
| 3 | 3 | https://www.lego.com/da-dk/product/trafalgar-square-21045 | Trafalgar Square | 12 | 1197 | 210452104521045 | 749 | 0.0 | 0.0 | 0.0 |
| 4 | 4 | https://www.lego.com/da-dk/product/the-white-house-21054 | Det Hvide Hus | 18 | 1483 | 210542105421054 | 719 | 0.0 | 0.0 | 0.0 |
| 5 | 5 | https://www.lego.com/da-dk/product/tokyo-21051 | Tokyo | 16 | 547 | 210512105121051 | 549 | 0.0 | 0.0 | 0.0 |
| 6 | 6 | https://www.lego.com/da-dk/product/new-york-city-21028 | New York City | 12 | 598 | 210282102821028 | 449 | 0.0 | 0.0 | 0.0 |
| 7 | 7 | https://www.lego.com/da-dk/product/paris-21044 | Paris | 12 | 649 | 210442104421044 | 449 | 0.0 | 0.0 | 0.0 |
| 8 | 8 | https://www.lego.com/da-dk/product/london-21034 | London | 12 | 468 | 210342103421034 | 399 | 4.0 | 4.1 | 4.0 |
| 9 | 9 | https://www.lego.com/da-dk/product/dubai-21052 | Dubai | 16 | 740 | 210522105221052 | 549 | 0.0 | 0.0 | 0.0 |
Last rows
| Unnamed: 0 | link | name | age | amount_bricks | product_number | price | rating_amount | rating_worth | rating_fun | |
|---|---|---|---|---|---|---|---|---|---|---|
| 504 | 504 | https://www.lego.com/da-dk/product/punk-pirate-beatbox-43103 | Punk Pirate BeatBox | 7 | 73 | 431034310343103 | 180 | 0.0 | 0.0 | 0.0 |
| 505 | 505 | https://www.lego.com/da-dk/product/unicorn-dj-beatbox-43106 | Unicorn DJ BeatBox | 7 | 84 | 431064310643106 | 180 | 0.0 | 0.0 | 0.0 |
| 506 | 506 | https://www.lego.com/da-dk/product/bandmates-43101 | Bandmates | 7 | 11 | 431014310143101 | 40 | 0.0 | 0.0 | 0.0 |
| 507 | 507 | https://www.lego.com/da-dk/product/water-tape-854065 | Vandbånd | 6 | 23 | 854065854065854065 | 80 | 0.0 | 0.0 | 0.0 |
| 508 | 508 | https://www.lego.com/da-dk/product/lego-xtra-sea-accessories-40341 | LEGO® xtra havudstyr | 6 | 24 | 403414034140341 | 40 | 0.0 | 0.0 | 0.0 |
| 509 | 509 | https://www.lego.com/da-dk/product/botanical-accessories-40376 | Plantetilbehør | 6 | 32 | 403764037640376 | 40 | 0.0 | 0.0 | 0.0 |
| 510 | 510 | https://www.lego.com/da-dk/product/sports-accessories-40375 | Sportstilbehør | 6 | 36 | 403754037540375 | 40 | 0.0 | 0.0 | 0.0 |
| 511 | 511 | https://www.lego.com/da-dk/product/xtra-chinatown-40464 | xtra Chinatown | 8 | 35 | 404644046440464 | 40 | 0.0 | 0.0 | 0.0 |
| 512 | 512 | https://www.lego.com/da-dk/product/xtra-food-40465 | xtra Mad | 6 | 36 | 404654046540465 | 40 | 0.0 | 0.0 | 0.0 |
| 513 | 513 | https://www.lego.com/da-dk/product/food-accessories-40309 | Madtilbehør | 6 | 30 | 403094030940309 | 40 | 0.0 | 0.0 | 0.0 |